
**********
*Table 1: Pre-crisis (2000-2013) attributes of municipality groups
**********

clear all
set more off
cap log close
cd ""
use , replace 

gen post = 0
replace post = 1 if year > 2013

***Groups
*1. Legal Amazon
gen treat = 0

*2. Pacaraima 
replace treat = 1 if munic_code == 140045

*3.  BR-174: Municipalities from the State of Roraima touched by BR-174: Amajari, Boa Vista, Caracarai, Iracema, Mucajai, Rorainopolis, Sao Luiz
replace treat = 2 if munic_code == 140002 | munic_code == 140010 | munic_code == 140020 | munic_code == 140028 | munic_code == 140030 | munic_code == 140047 | munic_code == 140060

*4. Non BR-174: Municipalities from the State of Roraima not touched by BR-174: Alto Alegre, Bomfim, Canta, Caroebe, Normandia, Sao Joao, Uiramuta
replace treat = 3 if munic_code == 140005 | munic_code == 140015 | munic_code == 140017 | munic_code == 140023 | munic_code == 140040 | munic_code == 140050 | munic_code == 140070


global x "life_expect illit_25 school gini poverty water_sewer  garbage electric female_pop agriculture fish construction mine def rain temp cattle rural"

tabstat $x if post == 0, statistics (n mean semean) by(treat)
